Heuristic query optimization for query multiple table and multiple clausa on mobile finance application

Improvements on a Heuristic Algorithm for Multiple-Query Optimization

Multiple query processing has received a lot of attention recently The problem arises in many areas such as extended relational database systems and deductive database systems In this paper we describe a heuristic search algorithm for this problem This algorithm uses an improved heuristic function that enables it to expand only a small fraction of the nodes expanded by an algorithm that has bee...

Applying Multiple Query Optimization in Mobile Databases

We apply multiple query optimization to batches of pull (on-demand) requests in a mobile database system. The resulting view can answer several queries at once, and it is broadcast on a view channel dedicated to common answers of multiple queries rather than over individual downlink channels. A performance study is conducted that simulates different query workloads. The results indicate a signi...

Multiple Range Query Optimization

In order to answer efficiently range queries in 2-d R-trees, first we sort queries by means of a space filling curve, then we group them together, and finally pass them for processing. Initially, we consider grouping of pairs of requests only, and give two algorithms with exponential and linear complexity. Then, we generalize the linear method, grouping more than two requests per group. We eval...

On Multiple Query Optimization in Data Mining

Traditional multiple query optimization methods focus on identifying common subexpressions in sets of relational queries and on constructing their global execution plans. In this paper we consider the problem of optimizing sets of data mining queries submitted to a Knowledge Discovery Management System. We describe the problem of data mining query scheduling and we introduce a new algorithm cal...

Multiple Query Optimization by Ca he - AwareMiddleware using Query